﻿CREATE TABLE [dbo].[TagDim]
(
	[TagId] BIGINT NOT NULL PRIMARY KEY, 
    [Name] NVARCHAR(250) NOT NULL, 
    [DisplayName] NVARCHAR(250) NOT NULL, 
    [Parent] BIGINT NULL, 
    [Unit] NVARCHAR(250) NOT NULL, 
    CONSTRAINT [FK_TagDim_ToTable] FOREIGN KEY ([Parent]) REFERENCES [TagDim]([TagId])
)
